.. _`Select columns in Table with Regex`:

.. _`org.sysess.sympathy.data.table.selecttablecolumnsregex`:

Select columns in Table with Regex
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.. image:: select_table_columns.svg
   :width: 48


Select all columns whose names match a regex.



**Documentation**

Select all columns whose names match a regex.


**Definition**


*Input ports*

    :port1:  table

        Input Table


*Output ports*

    :port2:  table

        Table with a subset of the incoming columns



*Configuration*:
    **Remove matching columns** (complement)
        When enabled, matching columns will be removed. When disabled, non-matching columns will be removed.
    **Search** (regex)
        Regex search pattern for matching column names.

.. automodule:: node_select_table_columns
    :noindex:

.. class:: SelectTableColumnsRegex
    :noindex:




**Related nodes**

* :ref:`org.sysess.sympathy.data.table.selecttablecolumns`
* :ref:`org.sysess.sympathy.data.table.selecttablecolumnstype`
* :ref:`org.sysess.sympathy.data.table.selecttablecolumnsfromtable`



**Example flows**

* :download:`SelectColumns.syx </_examples/Sympathy/Data Processing/Select/SelectColumns.syx>`